SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweSTecnicos
AS
SELECT     IDTecnico AS ID, ApellidoyNombre, IDAInformatica, EMail
FROM         dbo.Tb_STecnicos
GO
GRANT SELECT ON  [dbo].[vweSTecnicos] TO [Informatica]
GRANT INSERT ON  [dbo].[vweSTecnicos] TO [Informatica]
GRANT DELETE ON  [dbo].[vweSTecnicos] TO [Informatica]
GRANT UPDATE ON  [dbo].[vweSTecnicos] TO [Informatica]
GRANT SELECT ON  [dbo].[vweSTecnicos] TO [SoloVer]
GO
